Reviewing employee master
Overview
Use the Employee Listing sheet as reference to calculate when salary adjustments occur throughout the planning cycle. This sheet lists all employees by job code and includes details regarding each employee's current and next year's rate as well as their merit and market increase month and percentage.
Click image to view full size
To make the budget plan file as accurate as it can be when calculating salaries, the system takes into account any potential current year rate increases set to take place - depending on when the budget plan file is built. For example, let's say the following budget plan file is built in month 8. All the radiology technicians except Michael and Jeff have likely received their rate increases already because 0% displays in the CY Inc % column and their anniversary dates have already passed. However, Michael is set to receive his increase in month 9 and Jeff in month 10. The system anticipates this increase by showing that their beginning rate as 3% higher than their current rate and uses this rate for the budget.
The system does the same for scheduled budget market and merit increases as well. In this example, everyone will receive a 3% merit increase but no market increases. The system allows you to include up to two market increases, which simply provides a way to apply additional percentages beyond the merit increase. For example, a contract may stipulate that nurses receive two market increases per year.
The system then layers together all of the rate adjustments as well as the merit and market increases to provide you with values related to the amount that salaries will increase month-over-month over the year. In the following example, July starts with an increase of 0.70% but begins to increase month to month as more employees receive their salary adjustments. These values are used in the Jobcode tab to calculate salaries.
The last month of the fiscal year becomes the "fully burdened" month because by this point all of the increases have occurred. The effective rate for the fiscal year is located in the Total FTEs column. Knowing the effective rate helps you determine the effect of adding merit or market adjustments. In the example below, the user now knows that adding a 3% merit increase will result in a 1.67 effective rate.
The remaining section of the sheet is devoted to the scheduled hours for scheduled FTE employees. The system projects scheduled hours based on when the employee was hired and whether they are working full or part time.
Keep in mind the following when using this sheet:
- Employees are only listed in their home department. The Jobcode sheet may show more employees than what are listed for the job code in the Employee Listing sheet. This means that employees have been borrowed from other departments.
- The Employee Listing sheet only displays current active employees.
- To add an employee, you must do so through the labor method itself. For example, if you use the employee budgeting methodology, you must add a new employee in the Employee sheet.
- Merit and market increase factors are defined in the LaborRates sheet of the Budget Labor Assumptions driver
- This sheet incorporates max rate logic to calculate the lump sum payout if an employee is currently above their max limit or defined increases will put them above the limit.
- Max limits are defined in the
Use this sheet to calculate PTO accrual hours if activated in the Budget Configuration driver
